                     IMPORTANT INFORMATION
                     =====================

     !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
     !  Before unzipping the application files in PRODUCT.ZIP  !
     !  please read LICENS.TXT.                                !
     !  You must not unzip PRODUCT.ZIP only if you do not      !
     !  agree with the contents of LICENS.TXT                  !                                      !
     !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

     Installation
     ------------
     Please see INSTALL.TXT.

         --------------------------------------
         |               WARNING              |
         | The shareware version has been     |
         | "crippled". As long a unregistered,|
         | "nag" screens will appear now  and |
         | then as a reminder to register and |
         | a remark appears in letters.       |
         --------------------------------------

Registration
------------
You can register through RegNet.
  RepPoc LITE                US$24.95
  RepPoc PROF                US$39.95


RegNet - The Registration Network:
    RepPoc LITE:
       RegNet #:  1493
    RepPoc PROF
       RegNet #:  1494
    RegNet can be reached on the World Wide Web at the following URL:
        http://www.swregnet.com
    or by calling 1 800 WWW2REG (1 800 999-2734) or (805) 288-1827.

--------------------------------
Entering the registration number
--------------------------------

   Press MENU, / , ENTER, ENTER,
   then enter first name and the registration number.

   Note: The entered name must be part of the machines owner name.
         The registration number must be issued on the entered name.

Updates
-------

Updated versions can be downloaded from

http://www.online.de/home/lichtbild


Author contact
--------------
bdaum@online.de



Professional version for S3a
----------------------------

The professional version has additional functions:

  - Creating spreadsheets from DATA files
    and updating existing spreadsheets with DATA file contents.
  - Multifile links
  - Export of data to DATA files.



				RepPoc Version 4.0 - Release Notes
				===================================

Platforms
---------

RepPoc runs on PSION S3,S3a,S3c and Acorn PocketBook I and II in native mode.

RepPoc can be run on the S3a-emulator and supports screen sizes up to 640x400.
( Set SERVER_PARAMS -X640 -Y400 -D in HCSERVER.PAR for the big screen)

RepPoc LITE runs on Siena in S3 mode.
RepPoc PROF does not run on Siena or S3 classic.

Requirements
------------

RepPoc LITE: 56-84k disk space needed depending on options
RepPoc PROF: 84-112k disk space needed depending on options

Please see the installation routine for details.

RepPoc uses 32kB-64kB RAM when active.

We recommend to install the system on flash SSD, the REPORT folder
on the internal disk.

New in version 4.00
-------------------
    - File concatenation (PROF)
    - View fields (v.) can be used in sort and search criteria and forms
    - Evaluation operator =() for view fields
    - Import from agenda and spreadsheet (PROF)
    - more options when creating new form sheets
    - new text functions: 
	ASC_n::				Ascii code of n-th character
        CNTP::                          Counter for printed records
	CNT::, CNT1::, CNT2::   	Count of nonempty fields
	NCNT::, NCNT1::, NCNT2::	Count of fields with numeric value <> 0
	DATX_n::			Current date in different formats (n=0..9)
	LINE_n::			n-th nonempty line after current
    - The text functions CNTB:: andn CNTC:: have been removed.
    - new formatting functions: 
	"case1,case2,..."::
        Dn::  Date/time in different formats (n=0..9)
    - text/break functions can now be used in spreadsheets, too. (PROF)
    - optional output as plain text file

New in version 3.04
-------------------
    - The text function VAL:: can be used in sort criteria to sort
      records based on the numeric value of a field. Works also
      for date and time.

    - The numeric content of fields is now evaluated after nonnumeric
      characters (except decimal point) are removed from the field.
      An odd number of dashes makes the value negativ, an even
      number of dashes positive.
      (Previously a field containing nonnumeric characters had
       the value 0).

      Example:  $4,000.00-   results in -4000
                   - 13 -    result in 13

New in version 3.00
-------------------
    - Support for non-string fields in files (ODB files)
    - New relator =.. (starts with)
    - Formatting functions can be used on top of text functions
      for instance C2::sum::value
    - New formatting function for reports: B:: (Bargraph)
    - View definitions to customise screen display
    - Parameters for text functions
    - New text functions: cnta, cntb, cntc, csv, ssv, lcnt, left, right
    - New options for sorting
      Sort order: ascending/descending seperately for sort criterion 1/2
      Show: marked only (removes all non-marked records from selection set before sorting)
    - Support for Siena (LITE version only, in S3 mode)

    PROF version:
    - File links (up to 3 files) with multifile views
    - Export function to create new DATA files from view definition
    - Auto extend function for spreadsheet update


Program Description
-------------------
This is only a brief description of program facilities.
A comprehensive printed manual is shipped on registration.


RepPoc is a report writing and mail merging program based on
the PSION WORD and DATA formats.
It can be used to create lists, labels, letters, envelops from
selected database records. The print layout is controlled by forms
created with the WORD application.

To create a report you need:
	a database file                 (DAT\ folder)
	a form (WORD document)          (REPORT\FORMS\ folder)
	an output file (WORD document)  (WRD\ folder)
	a search criterion
	a sort criterion (optional)
	a view definition (optional)    (REPORT\FORMS\ folder)
	file links (optional)

The above file specifications and the search criterion are
stored in a report file (REPORT\ folder).

When you start the report application, you are first prompted
with the name of the DATA file and the search criterion.
At this stage you may want to modify this information. All changes
will be kept in the report file selected.

You can also re-specify the search criterion using the PSION-F
function (or the TAB key). This changes will go into the selected
report file, too.

Limitations
-----------

	-  Only a selection set of 256 records (1024 on S3a/S3c) can be viewed or sorted,
	   but you can print more.
	-  Records with a total length of more than 1022 bytes are not processed.
	-  Fields with more than 255 characters are not processed.
	-  only the first 32 fields of a record can be processed.


Searching
---------

The search criterion can be complex. It can consist of several
conditions.

'condition' has the following construction:

	fieldspec operator value

or

	fieldspec value

'fieldspec' has the following construction:


	label

or

	label[n]                n=1...9
				n identifies line number
				  for multiple line fields.
or

	txtfunc::label

or

	txtfunc::label[n]       n=1...9


'label' denotes the field of the DATA record, e.g. Name: or Work:
(Phone symbols are not written).

'txtfunc' denotes a valid text function (see below).

If a field has no label, it is addressed via a dummy label:

	field#nn

with "nn" being the field number (starting from 1 for the first field).


Valid operators are:
	=  <>   <   >   <=   >=		for alphanumeric comparisons (not case sensitive)
	=..                         start with
	== <<>> <<  >>  <==  >==    for numeric comparisons


If no operator is used, the condition is that the field denoted
by 'label' has to contain the value (not case sensitive).


Values are specified without quotes and can contain blanks. However,
they must not contain logical operators and paranthesis as separate
tokens.

Conditions can be combined with logical operators such as
	NOT   AND    OR    (       )

Example:

	work: germany and not ( notes: = no mail or field#5 berlin )

selects german business contacts but excludes the ones with the
remark "no mail" or where the second line of the address (field#5)
contains "berlin".

Search criterions treat multiple line fields (created with Shift-Enter)
as a whole.

Alternatively to a complex search criteria, you can enter the usual
search string, too. The string will be sought in any field of each record.
This is the only form of search criterion that can contain wild cards.


Only the records matching the search criterion are displayed. You
can scroll the records and from record to record in the same way
as in the DATA application. You cannot, however, update records.
You can use the dialling function, by pressing the dialling key.


Printing
--------

Despite of the name of this function, RepPoc does not output to a printer.
Instead it prints into a WORD document. This document can then be
opened with the word processor, modified and printed to any appropriate
printer.

However, this method can create a problem, as the output file can
become to large for the disk. If this happens, simply divide your
report into parts by modifiying the search criterium. Add, for
instance,  Name: < m  for the first part and   Name: >= m for
the second part.

When the print function is started, you are prompted for the
form sheet and the output file. Changes made here will be stored
in the current report file.

After the output file was created, you have the possibility to invoke
the word processor immediately and print you file from there.
However, you may want to leave RepPoc first and initiate the printing
from a separate task if you run into memory problems.

For letters, two more print modes exist. Instead of creating one big
document, RepPoc can create a single document for each letter. It will
invoke the WordProcessor for each letter to print the document. On an
S3a this can be done in an automated manner.
Generating letters as individual documents has the advantage that headers
and footers appear with each letter and that the page number is correct.


Form sheet
----------

You need a form sheet for printing. RepPoc gives some help
to create new form sheets. Use PSION-C to create a new form sheet.
The new sheet will contain a title paragraph, a header paragraph
(in the case of lists), and a body paragraph.

The body paragraph will contain field specification of the current
data file enclosed in   (left chevron, right chevron).
The chevrons can be entered via CTRL-174 and CTRL-175
(or CTRL-1 then "l", and CTRL-1 then "r" )but it is
much more comfortable to generate a form sheet with the PSION-C function
and to delete the fields not needed.

Field specifications are given in the same way as for search criteria
and can contain text functions and line numbers. In addition field speci-
fications can be prefixed with a record number for group processing.
The record number denotes the position of the record within the
record group processed with one formsheet.

The body paragraphs have slighty different layouts depending
on the form type (list, label, letter). For letters, e.g. the body
paragraph will start a new page.

After you have created a new form, you can edit immediately using
the PSION word processor. The word processor will be invoked automatically.
When you have done you changes, press PSION-X to return to RepPoc.
If you decide to modify after you have left RepPoc, move the highlight
under the WORD icon, press TAB, navigate to the REPORT\FORMS folder,
move the highlight to the new form and press ENTER.

Now you can rearrange the keywords, include some more text or tabs, etc.

Apart from the standard style sheets: HA,HB,BT,BL we have included
some new style sheets:

	HL      for list and report header
	LE      for list and report entry
	LB      for label
	LT      for letter
	PB      for page break (internal)
	TR      for report trailer

The style sheets HA, HL, and TR play an important role during report
generation:
	Only the bodytext is repeated.
	The bodytext is defined as the part between the last HA or HL style
	paragraph and the first TR style paragraph.
Empty paragraphs of style PB are inserted automatically at the beginning
of each repetition if a form contains at least one LT paragraph is found in
the bodytext.
So, letters start always with a new page.


Multiple record forms
---------------------
One formsheet can now refer to multiple records from the data
file, e.g. 1.Name 2.Name 3.Name ... 9.Name.
The maximum prefix in a formsheet defines the group size.
The record number always comes first, before the name and before an optional
text function. RepPoc will read as many records are required to process
the form sheet, and will then continue with the next group of records.
This feature is especially helpful for processing multi-column layouts, e.g.
for labels. (See LABEL.WRD)
It can be used in spreadsheets, too (PROF).


Multiple line fields
--------------------

These fields were created in DATA using Shift/Enter. When displayed
all lines are displayed.
However, during searching or when printed, only the first line is
used, unless specified otherwise. You may do so, by specifying

	Name:[n]                n = 1..9

for the n-th line of the Name: field.


Text functions
--------------

Text functions are used to derive information from field values
for printing, viewing, sorting, searching, linking.

RepPoc provides some predefined text functions. Functions
are specified in the following way:

	function::label

or

	function::label[n]

or if they have no argument

	function::


A full description of all text functions is contained in RPFUNC.DBF
(PSION database file) as an online reference.

You can write your own text function, too. The programming guidelines are 
in RPFUNC.DOC. It is a good idea to document all changes in RPFUNC.DBF.

A special group of text functions allows to accumulate numeric values over multiple records:

	pos::field    current position in list (no argument)
	sum::field    sum of the numeric value of that and the above fields.
	max::field    maximum of the numeric value of that and the above fields.
	min::field    minimum of the numeric value of that and the above fields.
	mean::field   mean of the numeric value of that and the above fields.
	cnt::field    count of nonempty fields
	ncnt::field   count of numeric content <> 0

Another group of functions allows break processing in sorted sets.

	SORTED::       Checks for sorted selection set.
	NEW1::field    Print field only if sort criterium 1 has changed.
	BRK1::         Counter for changes of sort criterium 1.
	POS1::
	SUM1::field
	MAX1::field
	MIN1::field
	MEAN1::field
	CNT1::field
	NCNT1::field
			Similar to POS,SUM,MAX,MIN,MEAN, but the values
			are reset when sort criterium 1 changes.
	NEW2,BRK2,POS2,SUM2,MAX2,MIN2,MEAN2
			are the same but are reset when sort 
			criteria 1 or 2 change.

	IF::field 	Print rest of paragraph if field content is >= "0"
	SKIPIF::field 	Skip rest of paragraph if field content is >= "0"

	HDR0:: 		Print rest of paragraph if the first character of
	        	sort criterium 1 has changed.
	HDR1:: 		Print rest of paragraph if sort criterium 1 has changed.
	HDR2::          Print rest of paragraph if sort criteria 1 or 2 has changed.
	TRL0::          Print rest of paragraph if the first character of
	                   sort criterium 1 will change.
	TRL1::          Print rest of paragraph if sort criterium 1 will change.
	TRL2::          Print rest of paragraph if sort criteria 1 or 2 will change.

	NPAG0::         Insert page break after current paragraph if
	                   the first character of sort criterium 1 will change.
	NPAG1::         Insert page break after current paragraph if
	                   sort criterium 1 will change.
	NPAG2::         Insert page break after current paragraph if
	                   sort criterium 1 or 2 will change.

	CHAR1::         Returns the first character of sort criterion 1.

Formatting functions:
---------------------

Formatting functions process field contents as numeric values and
to control their representation.
When used in spreadsheets they generate numeric cells.
Formatting functions can be used on top of text functions.

     Fn::   fix point with n decimal place (0...9)
     Sn::   Scientific with n decimal places (0...9)
     Cn::	currency with n decimal places (0...9)
     Pn::   percent with n decimal places (0...9)
     Nn::   thousandscomma with n decimal places (0...9)
     A::   Default
     G::   Floating point
     H::   Hidden
     B::   Bargraph
     Dn::   Date (number interpreted as days starting at 31.12.1899 as in spreadsheet)
           n specifies the format (0..9 as in Preferences).
     T::   Time (0.0...0.5...1.0 starting at midnight as in spreadsheet)
     "case1,case2,..."::
           selects substring depending on numeric value of operand

     VAL:: generic numeric value of field


Standard forms
--------------

We have already included some standard forms:

PHONES.WRD              landscape format phone list

LETTER.WRD              standard letterhead

FAX.WRD                 FAX cover sheet

ENVELOP.WRD             DL1 envelop

LABEL.WRD               address labels

ROLODEX.WRD             ROLODEX format address cards

You may want to modify these forms according to your requirements
and the printer you use.

Views
-----
Views are similar to forms but they control the appearance of data on the screen.
Views are edited through the DATA application (Create view, edit view).
You can remove fields, combine multiple fields into one field, apply text functions.
Use =( ) to evaluate arithmetic expressions in views.
In RepPoc PROF you can create multifile views and export views to new DATA files.
View fields can be used in search and sort criteria and forms (Prefix with "v.")

File links (PROF)
-----------------
Up to two secondary files can be joined or concatenated with the primary file.
For file joins specify the join criterium and options. The join criterium
consists of a secondary file field, a relator, and a primary field value
(can include text functions.)
Fields from secondary files can be used in forms and views, but not for
search and sort. They are identified by their names (as primary fields).
In case of ambiguity they can be prefixed with "b." (1.secondary file)
and "c." (2. secondary file).


Sorting
-------

After pressing PSION-S (sort function) you can specify up to 2 sort fields
(full fieldspec possible including text functions) and the sort direction
(ascending/descending).

Note, that not the whole file but only the selected records are sorted.
You can interrupt the sort process by pressing any key.

You may then view or print the records in sorted order.

You can reduce the selection set to only the records where the sort
criterion has changed.
Some text functions can react on changes (breaks) in the sort criterion
and allows you to create sophisticated reports with breaks, subtotals
and totals.


Marking
-------

During viewing, you may mark the selected records be pressing PSION-M or Shift/Enter.
When you print, you have the option to print only the records marked.
The mark symbol is shown in the top right corner of the screen.


Preferences
-----------

The preferences allow you to specify
- if the sort function shall be invoked every time
  the selection set becomes unsorted (especially when the file is opened).

- if you want to be prompted for data file, search criterion and sort criterion
  when the file is opened.


Spreadsheets (PROF)
-------------------

First use the function "New spreadsheet" and define the maximum number of lines.

RepPoc generates a title line and a control record. You may want to alter the
title line or the control record. The control record is used to generate the values
later on.

You can also copy this new spreadsheet into other existing spreadsheets.

Then use the "Update spreadsheet" function to insert the values.

When the contents of the DATA file have changed, use the update function
again, to replace the old values with the new ones.

For details about this function see the manual.

Import DATA from spreadsheet or agenda (PROF)
---------------------------------------------

Specify a spreadsheet or agenda file as primary or secondary data file.
and optionally specify a subrange (cell range, named range, interval).

For details about this function see the manual.


Troubleshooting
---------------

1. Line feed between entries is missing.

   Examine the form sheet. The last paragraph is probably not closed,
   i.e. when the cursor is moved to the end of the document, it will be
   at the end of the last line and not below the last line.
   Press ENTER to bring the cursor below the last line.

2. List headers or other header paragraphs repeat with the body text.

   You probably changed the format of these paragraphs. The WORD application
   has created a new style sheet (e.g. ZA) and assigned it to the paragraph.
   RepPoc cannot identify the paragraph as header paragraph because they have
   different names now.

   You can:

   a) reapply a Header Style sheet to the header paragraph (HA,HB,HL)
      and accomplish the necessary changes by modifying the settings
      of the header style sheet.
   b) create a short paragraph below the header paragraph and apply a header
      style sheet (HA,HB,HL) to it.

3. Conditional paragraphs don't appear at all.

   The paragraph was probable defined above a header paragraph. Move
   the paragraph to a position after the last header paragraph.

End of document
---------------






